<?php



class Query extends Database {

	
	
	public static function GetFilmsPourAffiche(){
        $semaine=Navig::getSemaineSelectionnee();
        $debut=Date::timestampToPattern($semaine['debut']);
        $fin=Date::timestampToPattern($semaine['fin']);
        $requete='SELECT * FROM film WHERE FILM_NUMID IN '.
                '(SELECT FILM_NUMID FROM programmation WHERE PROG_DATE '.
                "BETWEEN '$debut' AND '$fin')";
        return Film::populateList(self::query($requete));
	}


}

?>